UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hY0YmkQ6CZoyB4vEhIgOP6E1dj14xoK5zusq52cC9p0='
WHERE
key_id = '6d8f9c633d150cfd81c9727fb7047b321a49422aa567ff497014e0eb1a20c37e'
AND (
token = 'hY0YmkQ6CZoyB4vEhIgOP6E1dj14xoK5zusq52cC9p0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)