UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6cYOnttQ0JGdwklvpJU27PsBXrzeopoKBOv2oBPAuvg='
WHERE
key_id = '019b79144a155c7eb3dfb9a7ba3b19720e03525ce68cbc9066949483661a6d8b'
AND (
token = '6cYOnttQ0JGdwklvpJU27PsBXrzeopoKBOv2oBPAuvg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)