UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'RrHkXxK6+yD0TSq72XQ3ktHwrMH7JVPbjd6/2FydDf4='
WHERE
key_id = 'f7346c05191cdde4611be0ebcccc77ec4440352b784c1a524294de136bd46644'
AND (
token = 'RrHkXxK6+yD0TSq72XQ3ktHwrMH7JVPbjd6/2FydDf4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)