UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3PhJ3P19KStTUuXGfJYObak4dbZYoIOv9z5Hzvwq0eI='
WHERE
key_id = '7569d268c145a93cb8b4acf33553968f0fa412a275a5dd7b68e50f8e3b95c977'
AND (
token = '3PhJ3P19KStTUuXGfJYObak4dbZYoIOv9z5Hzvwq0eI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)