UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'lRmta9Cu8ejibE+mDLhusOdmZsNLPqpHWDaWolyfjqU='
WHERE
key_id = '6f4a46a0647012da6cc57d3692be11626fbe77b0a545d526de548e7feb8751b9'
AND (
token = 'lRmta9Cu8ejibE+mDLhusOdmZsNLPqpHWDaWolyfjqU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)