UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'FqlItghlS9W7vxxEp7T7RaftqdlknRNVYCmZhXhw1HU='
WHERE
key_id = '7dd7a9fdfac0d98ebae2325efab00fae1fa2a6c9ec0af6b2e0b019bdf9f1605d'
AND (
token = 'FqlItghlS9W7vxxEp7T7RaftqdlknRNVYCmZhXhw1HU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)