UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'yp8IK1KenklfCv1Wi3T1G6YHCBoJnrs1IEtACmK3824='
WHERE
key_id = 'd6344520e8e5e05160c2df11df2ee64ed83720b01575b677363961062aab2c2b'
AND (
token = 'yp8IK1KenklfCv1Wi3T1G6YHCBoJnrs1IEtACmK3824='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)