UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9cD+KlxPYUw8+lN2ImWAcpOt+y3S8Ckgfp0KQgGDPW0='
WHERE
key_id = '8a2d2f2e5d3ea24e22dd41b435c19014d2adef41b823dfc05af1c97759ff0074'
AND (
token = '9cD+KlxPYUw8+lN2ImWAcpOt+y3S8Ckgfp0KQgGDPW0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)