UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0fiXIdTkG3E7tW1RmDE34VrON1QivC1KH7aGUEk96kI='
WHERE
key_id = '3a1d1c0ca98e36b57233741459e75926320cca6351dd30c7bddb4f90eff0f537'
AND (
token = '0fiXIdTkG3E7tW1RmDE34VrON1QivC1KH7aGUEk96kI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)