UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'QW1dfqIZNr6f6K2F5vQTdjedCYBS+Kq/OJmifB/CHZU='
WHERE
key_id = 'd8110d2b34be6ad2318c4504d821d353aa2a9c96b2d595d4da007bfc44210130'
AND (
token = 'QW1dfqIZNr6f6K2F5vQTdjedCYBS+Kq/OJmifB/CHZU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)