UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3zwo8UH60dzwJCXEYlJT61gXkLydYVk+0FCENdKiLHM='
WHERE
key_id = '0b7b8aa43c39f20301ccb1f9deb86819c3f5b1f98ded2fe498798c61bf2b3f24'
AND (
token = '3zwo8UH60dzwJCXEYlJT61gXkLydYVk+0FCENdKiLHM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)