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