UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ERjNVXidTmpa4ifiHvHabptnIuNoOccJSzvb0wVYbsw='
WHERE
key_id = '71ac4aa2328becdd11ad20d5696525e8849011d9a25b332f463a9c43cd289c70'
AND (
token = 'ERjNVXidTmpa4ifiHvHabptnIuNoOccJSzvb0wVYbsw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)