UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pNJP6PuG0WyP8s2b2GioH9KLHzkxxaSGfSOmt3D/51k='
WHERE
key_id = '647022b420d9cc5d5f2f9ee4a74c8478691804ead83f57ae24290538e71fcdac'
AND (
token = 'pNJP6PuG0WyP8s2b2GioH9KLHzkxxaSGfSOmt3D/51k='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)