UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'y9ulydwYHLT5diUyWpFhj2SM3ouARUzaU7tyzo4tvio='
WHERE
key_id = 'bee6b5b7aa99ce33a8dc4a9ac3c3b6ad3fd18c77bc1644b52ed8f37f466dd893'
AND (
token = 'y9ulydwYHLT5diUyWpFhj2SM3ouARUzaU7tyzo4tvio='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)