UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Gs7TzcDK4WBYbCr70l2O1MGIHnRtJTfNjHo2gGA57WE='
WHERE
key_id = '08cfe6f56aa06f4ed8a7baf9c0d46a510ef5578e53698e9a3670321407e88498'
AND (
token = 'Gs7TzcDK4WBYbCr70l2O1MGIHnRtJTfNjHo2gGA57WE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)