UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'NKfbbZz6YI30Tc5Ri8o8iAjNimTDPv0OJeO5tfFRYXs='
WHERE
key_id = '5e877a42171fc14fa8467897344f9b77a1f46c318d4a29ed60b5cbf393461d63'
AND (
token = 'NKfbbZz6YI30Tc5Ri8o8iAjNimTDPv0OJeO5tfFRYXs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)