UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Ye0vT0+UL71992kFMdzf4rD+3SuyOvfxcg7aM54X4S8='
WHERE
key_id = '71d3aaf3e99039677396f928e70aa71a6f2454010515370b8dcac8cc35090682'
AND (
token = 'Ye0vT0+UL71992kFMdzf4rD+3SuyOvfxcg7aM54X4S8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)