UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8eMzQmi2nvDLtBW20Ml4JYaA65CJ0YM5LYBknrhlnX4='
WHERE
key_id = '4fdc1ec4ba33b07c774c4d48f315453541f116271a0811b1412a1302653fe935'
AND (
token = '8eMzQmi2nvDLtBW20Ml4JYaA65CJ0YM5LYBknrhlnX4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)