UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'aThFcXdZpIq+3uwO31NcBKr/qE2II25s82C0F0Z0YKc='
WHERE
key_id = 'bafa3554cc7da9af630c5611f533dea994e790822a864510b5e2a379c26b1f20'
AND (
token = 'aThFcXdZpIq+3uwO31NcBKr/qE2II25s82C0F0Z0YKc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)