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