UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zG/ribSTtoSKshDKpK3Pd+nqwBFP5t05cKYzvfDL9YU='
WHERE
key_id = 'f3364fb899c794b06ab69ec78c0a5e9316a64b2f76da02c90cdd7f48467240b2'
AND (
token = 'zG/ribSTtoSKshDKpK3Pd+nqwBFP5t05cKYzvfDL9YU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)