UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'JN28olSuTBOkopyqvcEIsSjFVP0WqAozau2Ttlnp7n0='
WHERE
key_id = 'f895211e7b290665f14cac2b81633e6faa2e500e4027ac5ba020da31aa04176a'
AND (
token = 'JN28olSuTBOkopyqvcEIsSjFVP0WqAozau2Ttlnp7n0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)