UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'PHjPdLbEj1TuMCnEqkoUmtMXxH0ZCiI1pse/6jkYJ38='
WHERE
key_id = '4cef42eead09206bd210c2895107a0221a885e382ab4f293a2a5ea8240005002'
AND (
token = 'PHjPdLbEj1TuMCnEqkoUmtMXxH0ZCiI1pse/6jkYJ38='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)