UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7XdUcaQKUeHkDMQ2RbqTdxMylDmG28xI8y8531b/oDg='
WHERE
key_id = '1e77af6a59cccf707b134415c6e9df8f667fe04e74a643da9879114a67bcff61'
AND (
token = '7XdUcaQKUeHkDMQ2RbqTdxMylDmG28xI8y8531b/oDg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)