UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7Ty6IwrqXE6mApbn20g/sdHI6mL67tCwTWdtz0EjXxw='
WHERE
key_id = '7b58585b361d20defb56cdf2cd363fd66e66b3206886923dd6550e86b9592ee6'
AND (
token = '7Ty6IwrqXE6mApbn20g/sdHI6mL67tCwTWdtz0EjXxw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)