UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zZ55MTEGF8oziy1Gw88ncIs5HWZh+EwIhE10DWEqV18='
WHERE
key_id = 'd4c78ff610be6dbe5895bb009a002ed81a5a613317fd8c200a35df50b1acb55d'
AND (
token = 'zZ55MTEGF8oziy1Gw88ncIs5HWZh+EwIhE10DWEqV18='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)