UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'RNbjPUv5yJuQKtGxtGrsWGGNTDSgIsC1CQv/HzSBZZE='
WHERE
key_id = '07b5c36c9d0435efaf0a72db4b6316ffa79064d6b913540a24b74d583cc164ea'
AND (
token = 'RNbjPUv5yJuQKtGxtGrsWGGNTDSgIsC1CQv/HzSBZZE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)