UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/U2pUGiRi1plYDd7SWzFkqCRf14U5RQAgWgI1jyLzww='
WHERE
key_id = '46f04a8aaa68edb497f7728df39d430a8cebbb3b54deff70a4d6d8703b9b9aef'
AND (
token = '/U2pUGiRi1plYDd7SWzFkqCRf14U5RQAgWgI1jyLzww='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)